Show AllThese suggestions apply only to consolidations that were created by using the Consolidate command on the Data menu. They do not apply to consolidations created by using 3-D references in formulas.
Check your source range references Make sure you entered the references to all source ranges correctly.
Check the summary function Make sure you selected the appropriate summary function in the Consolidate dialog box.
Check the consolidation To avoid problems with the shape of the destination area, select the upper-left cell of the area before you create the consolidation. Make sure you leave enough cells to the right and below this cell for the consolidated data. The Consolidate command fills in the area as needed.
Make sure each source area contains the same range of similar data in the same order.
Include row or column labels In the Consolidate dialog box, under Use labels in, make sure you selected the Top row or Left column check box, or both. And make sure you included corresponding labels in the source ranges.
Check for identical category labels Make sure you entered category labels with identical spelling and capitalization in all source areas. For example, labels Annual Avg. and Annual Average are different and will not consolidate.
Check for unique categories Make sure any categories that you don't want to consolidate have unique labels that appear in only one source range.
All consolidations